UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zbXzXnGBFDPN1D6fT5BDsRG2uW8zjCcBSCe7zhtSUU8='
WHERE
key_id = 'aec56126ac3e4a6e42c956a55cd9a242353eb34d9da7eb2046a5593b4312765e'
AND (
token = 'zbXzXnGBFDPN1D6fT5BDsRG2uW8zjCcBSCe7zhtSUU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)