UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H2CO085RFrILhRHHPE7nuIm/ny9ICLFfG0B9ebvgkcw='
WHERE
key_id = '6d3bc3ff0ef44163738cea0803255de0715656585fbaf2b30ff83926e64f766c'
AND (
token = 'H2CO085RFrILhRHHPE7nuIm/ny9ICLFfG0B9ebvgkcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)