UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXaKzQYnCbZnjYdYBAqjXuAjfGz7bNx025HP7VBWTkc='
WHERE
key_id = 'ef53c6c6da260864943086bd865470e29631488455bd7bcaade661bbae63f251'
AND (
token = 'pXaKzQYnCbZnjYdYBAqjXuAjfGz7bNx025HP7VBWTkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)