UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JPSBbw1qwAgBSxkFS/3mU0sZoALeZtSLwe2K6jx8h80='
WHERE
key_id = '5a6a3ec110232a1d80989aa775cacefa7fdf5059a7c720475db0aca6123d5545'
AND (
token = 'JPSBbw1qwAgBSxkFS/3mU0sZoALeZtSLwe2K6jx8h80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)