UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZur9byXPpbFCJf+2mcujDXMKgmn+4aEfHu2l9PngUw='
WHERE
key_id = '78c900c6df32eb3852d8fb0f7ec09560ddf2bf86655096467f91a195b73fd263'
AND (
token = 'PZur9byXPpbFCJf+2mcujDXMKgmn+4aEfHu2l9PngUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)