UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4egt6b6S2bjEpiuJDobYFPs3ubAJpfwdgxKk/Jr6/7M='
WHERE
key_id = '1a9f8c67a63f0b9bce94439eca811ec1c4d4dc58afa1d02118eb47bf92044d24'
AND (
token = '4egt6b6S2bjEpiuJDobYFPs3ubAJpfwdgxKk/Jr6/7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)