UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVj1oT+xqTBQpRyHE+zAutax/+czXJPII/wgLIT4in8='
WHERE
key_id = 'ac756001242503958e7b0c85816bdc835d08d858487f3b1ed751fb38242d39ab'
AND (
token = 'ZVj1oT+xqTBQpRyHE+zAutax/+czXJPII/wgLIT4in8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)