UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L4ZHKRDU5f6d7YCmguVbKFMIs28WLjQYJjVpCa88Txg='
WHERE
key_id = '29effc675ccc81564deeac1fd634eede038c6d5f6856f35b870df86956c3ecf2'
AND (
token = 'L4ZHKRDU5f6d7YCmguVbKFMIs28WLjQYJjVpCa88Txg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)