UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7DI6w1yEtBayGPRjZD8ZhB1DcbZ+CsxcRYVGij6Nyqk='
WHERE
key_id = '3ba4c1747674680c949620d0a4d32337928fba0157516f69988b5d9aaff1e33a'
AND (
token = '7DI6w1yEtBayGPRjZD8ZhB1DcbZ+CsxcRYVGij6Nyqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)