UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rmhSVYdOpnxkoSKNV3d68YtfWoW/dwWxJLb6E9FdnWk='
WHERE
key_id = '31c307b0740f31a1470b05620209e78fb5ee4a660c50be95c02df366dd7259f7'
AND (
token = 'rmhSVYdOpnxkoSKNV3d68YtfWoW/dwWxJLb6E9FdnWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)