UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K6E+AhJAcCLB/gGJ7S6hjx5pWye/B6p3qM6LyH15MGA='
WHERE
key_id = '7f9381f2e990a841b12b8c7d3549469a8c3fd31a2d08a074999afdf6433bc61e'
AND (
token = 'K6E+AhJAcCLB/gGJ7S6hjx5pWye/B6p3qM6LyH15MGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)