UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xKPwfnwpC7cMavEvkZ+3nWcPX5zzEh3H1KWASQwFbrA='
WHERE
key_id = '3ae7c5ace5deebfc17af8f147e43e925722a01363b9b963531f60a279839feb5'
AND (
token = 'xKPwfnwpC7cMavEvkZ+3nWcPX5zzEh3H1KWASQwFbrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)