UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r8w4ECWSM/qrOyzW5Ptaz/BuDZ1IGaBUlPg30cbGgiA='
WHERE
key_id = 'eb0593a7fc3d22f09d5f1e45c2e0d9e037024540718f02c3f8c238176ebf9893'
AND (
token = 'r8w4ECWSM/qrOyzW5Ptaz/BuDZ1IGaBUlPg30cbGgiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)