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