UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gG/NchpOeWe7/sHWAK7K8SvvKbkKrqdJ3cKaov5+97o='
WHERE
key_id = 'c7216292ccb01ae68d714a3ddf4dd8b60753706a6ef86e54e2f228667f580ff4'
AND (
token = 'gG/NchpOeWe7/sHWAK7K8SvvKbkKrqdJ3cKaov5+97o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)