UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9+N5FutM2SsU0BxCTWaOn9hFU0UZ5utU1E1k10w8wpE='
WHERE
key_id = '307d34df9f5e4a64952ab00af327ac45a7499b1ab2580314ea1d764bbf0bce0c'
AND (
token = '9+N5FutM2SsU0BxCTWaOn9hFU0UZ5utU1E1k10w8wpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)