UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N5LoXjmTOHLmvuNvHhwpDHIO1bJDZJBy9Wz95wvwyM4='
WHERE
key_id = '3657223ac2f27bda381c8e9e3ab35380ddcd89d68be785805447a3ceea48b978'
AND (
token = 'N5LoXjmTOHLmvuNvHhwpDHIO1bJDZJBy9Wz95wvwyM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)