UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C8dsbHL28qiqfW/O2bSn6e+LOaB70HkRVea3MBmqqes='
WHERE
key_id = '0c643a36b02f20632145a0f536e9bd41c000c18057858b49f0413ba90fc8b705'
AND (
token = 'C8dsbHL28qiqfW/O2bSn6e+LOaB70HkRVea3MBmqqes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)