UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZssYx2L0buxiKNLsqlvku5ADWSkNMIu98/vRMZ6Iw2U='
WHERE
key_id = 'b34bddcc5dda2711aa2140514a9b2de2b3bc6149dad8f5d68f5213ebaa1b830b'
AND (
token = 'ZssYx2L0buxiKNLsqlvku5ADWSkNMIu98/vRMZ6Iw2U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)