UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCSJ8HHvqkZqVSAU0tl088QXn7Lpu/uK/EpcwILjl7g='
WHERE
key_id = '57d9952e66581555386d5f2f2b95e295cb523420cb9cccee429f88f1e731100e'
AND (
token = 'pCSJ8HHvqkZqVSAU0tl088QXn7Lpu/uK/EpcwILjl7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)