UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sDc4XPojkU/o10goS8zJYxtboC/VR7WAMpz2p5M2P9M='
WHERE
key_id = '513d1fd3a244a48ad0015076a28d3a18def9a7b89a0be5e76a83da20de338fa0'
AND (
token = 'sDc4XPojkU/o10goS8zJYxtboC/VR7WAMpz2p5M2P9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)