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