UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KW3p3i9uP09t5Y7W4huOQeQXgb4F/peKgjtMDihAapU='
WHERE
key_id = 'ac4f5bf5ded403838788904a69f859bb7046a1b71d49d2821f15b03e7159e707'
AND (
token = 'KW3p3i9uP09t5Y7W4huOQeQXgb4F/peKgjtMDihAapU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)