UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HsR+z+nbH/sxF10Yvdw1OPD6THuhQZ2EJipX8dD87HY='
WHERE
key_id = 'de7f387cd2a43ce37705ca679019f9e2e680e8c66d34ce56453f3eb1d18b17e8'
AND (
token = 'HsR+z+nbH/sxF10Yvdw1OPD6THuhQZ2EJipX8dD87HY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)