UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ZCTw8CxP+NKEYdNzTvOWYdP5ePybRe8OWDco+8Bdxk='
WHERE
key_id = '21b031c243f730f179aed241e5e322e55279bd4e6b175c54bb8999f6b528173f'
AND (
token = '9ZCTw8CxP+NKEYdNzTvOWYdP5ePybRe8OWDco+8Bdxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)