UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GjYQkIZR30dfDOr9BwG6fDr3aPp+WOGWYJBuiZHh4l4='
WHERE
key_id = 'be97f5c7ef20ad291b9e795dc8241f32df20c40b91a543c6f31f6d32eded345e'
AND (
token = 'GjYQkIZR30dfDOr9BwG6fDr3aPp+WOGWYJBuiZHh4l4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)