UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pW5LA5d9mzd9pnGyaK4gXCS3drMh+JCqQGCWoNrfzD8='
WHERE
key_id = 'd1a4b7cf8587587b7de9aed0590e5e85f5bd0db506d76e49ee30505e93b0a50b'
AND (
token = 'pW5LA5d9mzd9pnGyaK4gXCS3drMh+JCqQGCWoNrfzD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)