UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgkZbaPcYUEhSppW/7zJqCLim+ax67OKkIsBcSCufrA='
WHERE
key_id = '9219b9a5856048dd9619c7cc458345894570b6720590c329cee258c6ab566db3'
AND (
token = 'BgkZbaPcYUEhSppW/7zJqCLim+ax67OKkIsBcSCufrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)