UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7k+2vHJp5HjygJqojVDrrhKbJ7Z1mILpbrMfSiiACks='
WHERE
key_id = 'f13916e73aaabe2bf9b003a12cfc08b79c857c95f3b1829fb452df1987707f87'
AND (
token = '7k+2vHJp5HjygJqojVDrrhKbJ7Z1mILpbrMfSiiACks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)