UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnSHZIQY/dCDsDeCbWi5HTax54xsxIUT1osJdrHxbTk='
WHERE
key_id = 'f133c732a5d02b1b4ebdc7b77fb7c1dc283cdc07f9f96781ebfe95155abb2971'
AND (
token = 'ZnSHZIQY/dCDsDeCbWi5HTax54xsxIUT1osJdrHxbTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)