UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8GXB+GoZqkx9ZJsBf5xTFJrCAWG5GOXWu9C5sblJRk='
WHERE
key_id = '7ca5e3be61fcdd56246eea7e7b1f8ddd193d0e1026f3295817acc9bc387a1f81'
AND (
token = 'R8GXB+GoZqkx9ZJsBf5xTFJrCAWG5GOXWu9C5sblJRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)