UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DlvHus5K1YECAKvEVbknieQLJh3I0spwSbPj8ypbkbI='
WHERE
key_id = '8d25f6670e75e27f3bc43db8f7b7d6e36ef91713cfe234cf8f9c6c65ed22884a'
AND (
token = 'DlvHus5K1YECAKvEVbknieQLJh3I0spwSbPj8ypbkbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)