UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qIF1xaGeEpKIEtBnmjQ9lPmgKm+NtjFEdKBhL5twr88='
WHERE
key_id = '9fa9b78f03b49ad9b4cac0e412e442b29d677554d9643d565e242c11184771af'
AND (
token = 'qIF1xaGeEpKIEtBnmjQ9lPmgKm+NtjFEdKBhL5twr88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)