UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCG8hNzMjDLjHCRJsYglQw+IMlI7nK2Gv0uOjK4/8BM='
WHERE
key_id = '8a87a59beffcea41c96a74184f1fd1645b727608faccd88dcab8dbc9dc276030'
AND (
token = 'pCG8hNzMjDLjHCRJsYglQw+IMlI7nK2Gv0uOjK4/8BM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)